Analysis of a failure

نویسنده

  • Nenad Jukic
چکیده

Defining data warehouse requirements is widely recognized as one of the most important steps in the larger data warehouse system development process. This paper examines the potential risks and pitfalls within the data warehouse requirement collection and definition process. A real scenario of a large-scale data warehouse implementation is given, and details of this project, which ultimately failed due to inadequate requirement collection and definition process, are described. The presented case underscores and illustrates the impact of the requirement collection and definition process on the data warehouse implementation, while the case is analyzed within the context of the existing approaches, methodologies, and best practices for prevention and avoidance of typical data warehouse requirement errors and oversights. DOI: 10.4018/jbir.2010070105 International Journal of Business Intelligence Research, 1(3), 66-76, July-September 2010 67 Copyright © 2010, IGI Global. Copying or distributing in print or electronic forms without written permission of IGI Global is prohibited. 2006). Within the past decade data warehousing projects have been receiving a growing amount of attention and resources in the majority of large and mid-size organizations. A recent study reports typical cost for creating a one terabyte data warehouse of several million USD with a typical implementation time of several years (Gray, 2006). There are no definitive numbers on the failure rate of data warehousing projects, but estimates vary from as little as 20% to as high as 90% (Watson et al., 1999; Frolick & Lindsey, 2003; Watson, 2005; Hwang & Xu, 2007). As is the case with estimating the failure rates of all IT projects, one of the reasons for the wide discrepancy in estimated failure rates of data warehousing projects is the absence of an agreement of what constitutes a failure. For example, there is no unambiguous answer to the question: does abandoning the initial design, scope, strategy, infrastructure or technology of a data warehouse design constitutes a failure? In some cases the answer is a definitive yes. On the other hand, in cases where such abandonment is accompanied by learning lessons that allow for the adoption of successful alternatives which eventually result in a properly designed and used data warehouse, it is appropriate to exempt such cases from a label of outright failure, given that the outcome is in line with the concept of a successful failure. Although it is hard to establish a precise overall failure rate of data warehousing projects, the fact remains that some data warehousing projects (just like any other IT projects) fail. The literature indicates that there are many, often intertwined, factors that can cause data warehouse project failure, such as budget overruns, unacceptable performance, poor quality data, weak sponsorship, and lack of long-term planning, etc (Stackowiak, 1997; Adelman & Moss, 2000; Goldman, 2001; Frolick & Lindsey, 2003; Hayen, Rutashobya, & Vetter, 2007). As do most information system development processes, data warehousing projects follow some form of a System Development Life Cycle (SDLC). SDLC is the overall process of developing information systems through a multi-step process including steps such as planning, analysis, design and implementation (Dennis, Wixom, & Roth, 2006). One popular data warehouse-focused variation of the SDLC is the Data Warehousing Lifecycle (Kimball, Ross, Thornthwaite, Mundy, & Becker, 2007) illustrated in Figure 1. Certain steps (such as product selection, project initiation, etc.) are omitted for brevity. The depicted steps are common to any data warehousing project: Figure 1. Abbreviated data warehouse system development lifecycle 9 more pages are available in the full version of this document, which may be purchased using the "Add to Cart" button on the product's webpage: www.igi-global.com/article/data-warehousing-requirementscollection-definition/45727?camid=4v1 This title is available in InfoSci-Journals, InfoSci-Journal Disciplines Business, Administration, and Management. Recommend this product to your librarian: www.igi-global.com/e-resources/libraryrecommendation/?id=2

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Developing a Method for Risk Analysis in Tile and Ceramic Industry Using Failure Mode and Effects Analysis by Data Envelopment Analysis

The failure mode and effects analysis (FMEA) is a widely used analytical technique that helps to identify and reduce the risks of failure in a system, component, or process. One important issue of FMEA is the determination of the risk priorities of failure modes. Risk ranking is produced in order to prioritize the focus on each of the failure modes that are identified. In this study, we applied...

متن کامل

Prioritizing Potential Risks based on Failure Mode and Effects Analysis Using Data Envelopment Analysis: a case study

The need to establish power plants to supply the required electricity of the country has been rising due to increasing demand levels as well as the lack of governmental resources. Furthermore, the available traditional attitude in performing and conducting power plant projects has made government seek a modern attitude. This paper tries to use the topics that have been employed in automotive in...

متن کامل

Reliability analysis of suspension bridges against buffeting failure

A reliability analysis of suspension bridges against buffeting failure due to gustiness of wind velocity is carried out using the concept of PRA (probabilistic risk analysis) procedure. For this purpose, the bending stresses at the critical nodes of the bridge deck are obtained for buffeting forces using a spectral analysis technique and a finite element approach. For the purpose of reliability...

متن کامل

A Fuzzy Approach to Sequential Failure Analysis Using Petri nets

In highly competitive industrial market, the concept of failure analysis is an unavoidable fact in complex industrial systems. Reliability of such systems not only depends on the reliability of each element of these systems, but also depends on occurrence of sequence of failures. In this paper, a novel approach to sequential failure analysis is proposed which is based upon fuzzy logic and the c...

متن کامل

Modeling and Availability Analysis of Internet Data Center with various Maintenance Policies

In this paper, the authors have focused on the stochastic analysis of an internet data center (IDC), which consists of a database main server connected to a redundant server. Observing the different possibilities of functioning of the system, analysis has been done to evaluate the various reliability characteristics of the system. The system can completely fail due to failure of redundant serve...

متن کامل

Failure Mode and Effects Analysis Using Generalized Mixture Operators

Failure mode and effects analysis (FMEA) is a method based on teamwork to identify potential failures and problems in a system, design, process and service in order to remove them. The important part of this method is determining the risk priorities of failure modes using the risk priority number (RPN). However, this traditional RPN method has several shortcomings. Therefore, in this paper we p...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2015